import pandas as pd
import plotly.express as px
start_row = 0 # Include the header row
end_row = 94 # Include the last row of the dataset
# Assuming you have an Excel file named 'data.xlsx' with a sheet named 'sunburst_data'
df = pd.read_excel('Sunburst_20231206.xlsx', sheet_name='sunburst_data', nrows=end_row, skiprows=start_row)
fig = px.sunburst(df, path=['Domain', 'Need', 'Service'], values='Percentage',
title='Interactive Sunburst Chart',
width=800, height=800
)
fig.show()
Domain Evaluation Need Reflecting on future improvements Service NaN Percentage 1.0 Name: 93, dtype: object
Domain NaN Need NaN Service NaN Percentage NaN Name: 94, dtype: object